/*
Navicat MySQL Data Transfer

Source Server         : mysql
Source Server Version : 50716
Source Host           : localhost:3306
Source Database       : rolesystem

Target Server Type    : MYSQL
Target Server Version : 50716
File Encoding         : 65001

Date: 2017-12-21 14:20:32
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for think_auth_group
-- ----------------------------
DROP TABLE IF EXISTS `think_auth_group`;
CREATE TABLE `think_auth_group` (
`id`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`title`  char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`status`  tinyint(1) NOT NULL DEFAULT 1 ,
`rules`  char(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`detail`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=20

;

-- ----------------------------
-- Records of think_auth_group
-- ----------------------------
BEGIN;
INSERT INTO `think_auth_group` VALUES ('1', '超级管理员', '1', '1,2,3,4,5,6,7,8,9,10,11,12,13,21,14,15,16,17,18,19,20,22,23', '对用户进行增删改查操作'), ('2', '管理员', '1', '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,19,20,21,17', '修改，删除及添加用户'), ('3', '普通用户', '1', '1,2,3,4', '查看个人信息及密码修改');
COMMIT;

-- ----------------------------
-- Table structure for think_auth_group_access
-- ----------------------------
DROP TABLE IF EXISTS `think_auth_group_access`;
CREATE TABLE `think_auth_group_access` (
`uid`  mediumint(8) UNSIGNED NOT NULL ,
`group_id`  mediumint(8) UNSIGNED NOT NULL ,
UNIQUE INDEX `uid_group_id` (`uid`, `group_id`) USING BTREE ,
INDEX `uid` (`uid`) USING BTREE ,
INDEX `group_id` (`group_id`) USING BTREE 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of think_auth_group_access
-- ----------------------------
BEGIN;
INSERT INTO `think_auth_group_access` VALUES ('1', '1'), ('2', '2'), ('3', '3'), ('4', '3'), ('5', '3'), ('6', '3'), ('7', '3'), ('8', '3'), ('9', '3'), ('10', '3'), ('11', '3'), ('12', '3'), ('13', '3'), ('14', '3'), ('15', '3'), ('20', '2'), ('22', '0'), ('23', '1'), ('24', '3'), ('25', '0'), ('26', '0'), ('27', '2'), ('28', '0');
COMMIT;

-- ----------------------------
-- Table structure for think_auth_rule
-- ----------------------------
DROP TABLE IF EXISTS `think_auth_rule`;
CREATE TABLE `think_auth_rule` (
`id`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`name`  char(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`title`  char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`type`  tinyint(1) NOT NULL DEFAULT 1 ,
`status`  tinyint(1) NOT NULL DEFAULT 1 ,
`condition`  char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`pid`  int(11) NULL DEFAULT NULL ,
`is_menu`  int(255) NULL DEFAULT NULL ,
PRIMARY KEY (`id`),
UNIQUE INDEX `name` (`name`) USING BTREE 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=24

;

-- ----------------------------
-- Records of think_auth_rule
-- ----------------------------
BEGIN;
INSERT INTO `think_auth_rule` VALUES ('1', '', '基本信息', '1', '1', '', '0', '1'), ('2', 'home/user/info', '个人信息', '1', '1', '', '1', '1'), ('3', 'home/user/login', '登录页', '1', '1', '', '0', null), ('4', 'home/user/updatepwd', '修改密码', '1', '1', '', '1', '1'), ('5', 'home/user/role', '角色管理', '1', '1', '', '13', '1'), ('6', 'home/user/auth', '权限管理', '1', '1', '', '13', '1'), ('7', 'home/user/serverdblist', '用户列表数据', '1', '1', '', '13', null), ('8', 'home/user/items', '用户列表', '1', '1', '', '13', '1'), ('9', 'home/user/tianjia', '添加用户', '1', '1', '', '13', null), ('10', 'home/user/genxin', '编辑用户', '1', '1', '', '13', null), ('11', 'home/user/delete', '删除用户', '1', '1', '', '13', null), ('12', 'home/user/rolelist', '查询用户身份', '1', '1', '', '13', null), ('13', 'home/user/index', '系统管理', '1', '1', '', '0', '1'), ('21', 'home/user/rules_delete', '删除权限', '1', '1', '', null, null), ('14', 'home/user/search', '查询对应用户身份', '1', '1', '', null, null), ('15', 'home/user/newrole', '添加角色', '1', '1', '', null, null), ('16', 'home/user/role_delete', '删除角色', '1', '1', '', null, null), ('17', 'home/user/authlist', '权限表', '1', '1', '', null, null), ('18', 'home/user/roledetail', '显示权限详情', '1', '1', '', null, null), ('19', 'home/user/loadrole', '加载用户身份', '1', '1', '', null, null), ('20', 'home/user/bigger', '获取最大', '1', '1', '', null, null), ('22', 'home/user/loadrule', '加载所缺权限', '1', '1', '', null, null), ('23', 'home/user/addrule', '添加权限', '1', '1', '', null, null);
COMMIT;

-- ----------------------------
-- Table structure for think_member
-- ----------------------------
DROP TABLE IF EXISTS `think_member`;
CREATE TABLE `think_member` (
`nickname`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`username`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`password`  int(255) NULL DEFAULT 123 ,
`address`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`company`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`work`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`phone`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`birthday`  date NULL DEFAULT NULL ,
`role`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=28

;

-- ----------------------------
-- Records of think_member
-- ----------------------------
BEGIN;
INSERT INTO `think_member` VALUES ('啦啦', '1', '刘一', '123', '湖如果', '海棠', 'rgn', '18512341236', '2017-12-29', '超级管理员'), ('大海2', '2', '刘二', '1234', '南野', 'FRwg', '程序员', '13412341234', '2017-12-01', '管理员'), ('大海3', '3', '刘三', '12', '南野', 'frf', '程序员', '13412341234', '2017-12-29', '普通用户'), ('大海4', '4', '刘四', '12', '南野', 'dQFC', '程序员', '13412341234', '2017-12-24', '普通用户'), ('大海5', '5', '刘五', '12', '南野', 'FRRR', '程序员', '13412341234', '2017-12-03', '普通用户'), ('大海6', '6', '刘六', '12', '南野', 'FRW', '程序员', '13412341234', '2017-11-28', '普通用户'), ('大海7', '7', '刘七', '12', '南野', 'FRW', '程序员', '13412341234', '2017-11-28', '普通用户'), ('大海8gr', '8', '刘八', '12', '南野', 'FRW', '程序员', '13412341234', '2017-11-28', '普通用户'), ('摩西', '9', '刘九', '123', '北京', null, '药师', '17612341234', '2017-12-27', '普通用户'), ('2额', '10', '十一', '123', '非法', null, '如果', '13412341234', '2017-12-29', '普通用户'), ('珊瑚', '13', '姗姗', '123', '上海', null, '作家', '17612341236', '2017-12-27', '普通用户'), ('风味', '14', '谷歌', '123', '广州', null, '教师', '13212341234', '2015-08-05', '普通用户'), ('核儿', '15', '古月', '123', '北京', null, '魔术师', '17689001234', '2017-12-28', '管理员'), ('的v', '16', '小浪', '123', '北京', null, '的', '13312341234', '2017-12-27', '普通用户'), ('任务的', '18', '流水', '123', '北京', null, '恶女', '18712341234', '2017-12-29', '普通用户'), ('额', '19', '地方 ', '123', '北京', null, 'e', '13212341234', '2018-01-04', '无'), ('rveb', '20', 'efcr', '123', '深圳', null, '2e', '13212341234', '2017-12-30', '管理员'), ('dwd', '21', 'lala', '123', '北京', null, 'wef', '13412341234', '2017-12-26', '普通用户'), ('43t', '22', 'grb', '123', '北京', null, '42', '13412341234', '2017-12-27', '无'), ('dewf', '23', 'hurv', '123', '北京', null, '2ee', '13212341234', '2017-12-28', '超级管理员'), ('瑞瑞', '24', '夕月', '123', '北京', null, '全额', '18712341234', '2017-12-28', '普通用户'), ('任务', '25', '小新', '123', '北京', null, '日', '13212341234', '2017-12-28', '无'), (' gre', '26', '访问', '123', '北京', null, '王t', '13312341234', '2017-12-27', '无'), ('如果', '27', '咯', '123', '北京', null, 'gr', '13212341234', '2017-12-28', '管理员');
COMMIT;

-- ----------------------------
-- Auto increment value for think_auth_group
-- ----------------------------
ALTER TABLE `think_auth_group` AUTO_INCREMENT=20;

-- ----------------------------
-- Auto increment value for think_auth_rule
-- ----------------------------
ALTER TABLE `think_auth_rule` AUTO_INCREMENT=24;

-- ----------------------------
-- Auto increment value for think_member
-- ----------------------------
ALTER TABLE `think_member` AUTO_INCREMENT=28;
